<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="${package.Mapper}.${table.mapperName}">

    <!-- 列表 -->
    <select id="list" resultType="${package.Entity}.${entity}DTO">
        SELECT * FROM ${table.name} where is_deleted = 0
    </select>

    <!-- 详情 -->
    <select id="getById" resultType="${package.Entity}.${entity}DTO">
        SELECT * FROM ${table.name} where id = ${r"#{id}"}
    </select>

</mapper>